Setting Database Permissions

In SQL Server 2005 or above, in the grid, check Grant, Grant Option or Deny against the permission listed in Permission to assign this database role to have that permission. Multiple permissions can be granted.

To grant (select) or revoke (unselect) all permissions, control-click the grid and select Grant All, Grant All With Grant Option, Deny All or Revoke All option.